Skip to main content

What’s New

Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
NodeJS Deprecation
AWS has announced that it is deprecating NodeJS 12, 14, and 16. To avoid any issues as a result of this deprecation, upgrade your instances of the Qrvey platform as described in this announcement.
Learn More
Version: 8.5

Overview of Formula Builder

Formula Builder is an interactive user interface that enables you to quickly create, test, and save formulas. Formulas enable you to create new columns of data that do not already exist in the dataset. For example, you can create a formula to segment data, aggregate data, calculate ratios, and much more. Once a formula is created and saved, it is available in Chart Builder, Pixel-perfect Reports, and the Analyze widget as a new column that can be added to a chart or visualization. The Qrvey platform computes the values of that column in real time, when the end user displays the chart or visualization.

For a video tutorial on using Formula Builder, see the video Formulas and Buckets.

Formula Builder is opened from within Chart Builder, Pixel-perfect Reports, or the Analyze widget. Click the sigma icon on the toolbar:

icon-composer-formula-builder-82

The Formulas dialog displays with a list of existing formulas.

formulas-dialog-82

To create a new formula, click Create Formula. The Create Formula dialog displays.

Formula Builder provides the following two modes for creating formulas:

  • Data Engine Syntax (legacy). Create formulas using a database-specific syntax. For more information, see Using Data Engine Syntax Mode.
  • Standardized Syntax. Create formulas using a standardized syntax that is compatible with any database connected to the Qrvey platform. Introduced in Version 8.2. For more information, see Using Standardized Syntax Mode.

The Formula Builder Interface​

The Formula Builder interface consists of three main sections:

  • Formula. The editor in which you write the formula.
    • Standardized Syntax also provides a Testing tab, which enables you to define the input data to test your formula. For more information, see Using Standardized Syntax Mode.
    • Data Engine Syntax provides a Test link that tests the formula using random values from the dataset.
  • Insert Functions. Lists all the functions available to use in your formula, provides a helpful description of each function, and enables you to add functions to the formula.
  • Insert Columns. Lists all the dataset columns available to add to your formula.

formula-builder-data-engine-syntax-82

Using Formulas​

After creating and saving a formula, it displays in the Data panel along with the other columns in the dataset. Formulas are indicated by the sigma icon before the name. You can select and use formulas in the same manner as other columns in various features including charts, filters, Automation, and Pixel-perfect Reports.

The following screenshot of Chart Builder includes several formulas in the Data panel:

chart-builder-with-formulas-82

See also: